HW#3 --- last modified February 17 2019 19:38:07..

Solution set.

Due date: Apr 8

Files to be submitted:
  Hw3.zip

Purpose: To experiment more with SQL in the DB2 environment. To learn more about DB2 cooperates with other facilities in the z/OS environment.

Related Course Outcomes:

The main course outcomes covered by this assignment are:

(2) Describe the system environment of DB2 on z/OS, understand how DB2 cooperates with other facilities within this environment. (3) Develop applications using DB2 on z/OS as a data server. (5) State basic DB2 management issues.

Specification:

Your Hw3.zip file should contain two main files: Assignment.html and Lab.php . The assignment file should contain your solutions to the multiple choice problems below. The lab file should contain transcripts and screenshots from your SPUFI and control center sessions as well as anything else needed to assignment the lab portion of the assignment.

Assignment Component

For this portion you should answer the following multiple choice problems. To do this you might need to examine the online DB2 Reference Center. Besides choosing what you think is the correct answer to each question you should provide a short explanation in your own words justifying your answer. An answer without a coherent justification will not receive any credit.

1. Which of the following is NOT the responsibility of DFSMS?
   1. Handling physical data backup and recovery
   2. Performing migration and recalling data
   3. Spacing management
   4. Repairing damaged data
2. To the same DB2 object O, application A1 has been holding a certain lock on it. In the meantime, application A2 attempts an X lock on O but failed; application A3 attempts an U lock and failed again; application A4 attempts an S lock and succeeds. What type of lock is A1 holding on the object O?
   1. S
   2. U
   3. X
   4. Either S or U
3. Which of the following problem maybe addressed in attachment facilities?
   1. Security
   2. Cross the address space boundary
   3. Resource recovery coordination
   4. Bind out
   1. i, ii, iii
   2. ii, iv
   3. iii, iv
   4. i, ii, iii, iv
4. Which of the following statements is NOT true about DB2 thread?
   1. DB2 thread is a set of internal control blocks which DB2 uses to track a user's work
   2. DB2 thread is used to send requests from programs to DB2, send data from DB2 to programs, and to communicate (with SQLCA) the status of SQL execution.
   3. Each program must connect to DB2 by means of a thread
   4. A thread is created when the connection is established and deleted when the connection terminates
5. Which of the following mechanisms is NOT performed by WLM?
   1. Measure the time to run each individual workload
   2. Find out the contention points
   3. Kill work running in the system
   4. Identify the work running in the system
6. What is NOT the best practice for WLM managing DDF?
   1. Dividing incoming requests by their targeted DB2 subsystems
   2. Assigning more resource to dynamic queries
   3. Dividing incoming requests into static and dynamic groups
   4. Dividing incoming requests based on business classification requirements
7. (1)What are the correct system configurations regarding to DDF, if you have a Windows DB2 connecting to z/OS DB2 for database request?
   1. You need DDF client on Windows and DDF server on z/OS.
   2. You need DDF client on Windows, no DDF server on z/OS.
   3. You don't need DDF client on Windows; you only need DDF server on z/OS.
   4. You need both DDF client and servers on both Windows and z/OS.
8. (1)Which of the DRDA level is not supported in DDF?
   1. Remote request
   2. Remote unit of work
   3. Distributed request
   4. Distributed unit of work
9. Which catalog table contains space information of a storage group?
   1. SYSIBM.SYSSTOGROUP
   2. SYSIBM.SYSVOLUMES
   3. Both of the above
   4. Neither of the above
10. (6) Which of the following statement has "LOCKSIZE" parameter?
    1. Create database
    2. Create tablespace
    3. Create table
    4. Create index

Lab Component

Varian has now posted Labs 6, 7, 8. To do the lab component of this homework, go through these labs answering the questions therein. Keep a transcript of your SPUFI sessions. Put these all into Lab.html). Use the same manual method for creating html files as was used for Hw1.

Point Breakdown